UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BGEog8crDLtYnp2HW57DK57bar1RDcOSSsjmI3XKvGU='
WHERE
key_id = '3b21d0b255c1cda5b1a1ce8e0eec9ca8fea0898247daa8906be729e54bd4ce46'
AND (
token = 'BGEog8crDLtYnp2HW57DK57bar1RDcOSSsjmI3XKvGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)