UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1YYxBCFmK+056o+PjnvHAG7PF4RqbWVoEA5PEz+sKQM='
WHERE
key_id = '1ed89d751ac60dfb39f7be9da7ca22232ec0e1f2e472f67daf7748ae89dcbf07'
AND (
token = '1YYxBCFmK+056o+PjnvHAG7PF4RqbWVoEA5PEz+sKQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)