UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HwiUut5L9bL0o6CLXpm9boWCwUtgzhcVXKB/OgZrg9o='
WHERE
key_id = '3afa48dba6387f3ff81eae7ada48e9fefed18361d7aaa46fb0111453365b45a1'
AND (
token = 'HwiUut5L9bL0o6CLXpm9boWCwUtgzhcVXKB/OgZrg9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)