UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7iGWP5Ddt9hflvPAN7MhXtWFQ2Gmb5PQlGhRxfxAtKo='
WHERE
key_id = 'ed26bcae10251aef794089fc4aa218da878aed2877a0164ee4b0522faf0a06bb'
AND (
token = '7iGWP5Ddt9hflvPAN7MhXtWFQ2Gmb5PQlGhRxfxAtKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)