UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xZbd7KCc0UeUyv7fduV6hv69B5VZ0318FN23ZL9fHY='
WHERE
key_id = '1269bb1059460a7c2463b72e62b668738bf40cc377122c69f1450ace1fbbe5ca'
AND (
token = '0xZbd7KCc0UeUyv7fduV6hv69B5VZ0318FN23ZL9fHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)