UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e7lg9HOWsXAlVVWLBLsva9qGpwvKWIwhH3p8vpxp3pg='
WHERE
key_id = 'a88bab34dc8dc31a9436e6a3f112a972f146768755d753c702e7b7f40906d51c'
AND (
token = 'e7lg9HOWsXAlVVWLBLsva9qGpwvKWIwhH3p8vpxp3pg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)