UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LYmXmcAC+ol7ymCu2eKFpJvE8lO2EH4QQwv01B/eWWE='
WHERE
key_id = 'a6be0af995d88d65e79b8de5e9bd47c0a98cfa095f2578d1bc0c6233bb3f4227'
AND (
token = 'LYmXmcAC+ol7ymCu2eKFpJvE8lO2EH4QQwv01B/eWWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)