UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oHJ3ahAhG9zUzAW/wmfz8rDz3x4YpgE26hPs16zTSjU='
WHERE
key_id = '23579f0a80447eee3f93bace8e6110b5a81f914314165ce62bff096a19e382f9'
AND (
token = 'oHJ3ahAhG9zUzAW/wmfz8rDz3x4YpgE26hPs16zTSjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)