UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'akF5gxApRMRy3oyl/sAXH2hXVdXENARboodzf0MxPb8='
WHERE
key_id = 'cea0d9beed1cd5081001339f8326908109e696646e52a109a34104ad012336a9'
AND (
token = 'akF5gxApRMRy3oyl/sAXH2hXVdXENARboodzf0MxPb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)