UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XdOZRW4chpMboclpChclf1QGtl/R70vIq7OMH98u/GE='
WHERE
key_id = 'd6f2a0c319b3102ab8f65106e8013f5eb1c1e3cb14cfa5eb068494c9f3ce6385'
AND (
token = 'XdOZRW4chpMboclpChclf1QGtl/R70vIq7OMH98u/GE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)