UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RhB3wd28cgvUx4zDglyZu3I9HpFe9bU5U1TzzBA5DVU='
WHERE
key_id = '365c73cb6e890044c68e936d97a093d11d126bbd4b447c6be9db2862bd3478fb'
AND (
token = 'RhB3wd28cgvUx4zDglyZu3I9HpFe9bU5U1TzzBA5DVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)