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