UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TxvlLXMFO0D/ehYf/P6VGThdw11hOFJWdoHtjswHPY='
WHERE
key_id = '4867b6ee0c2320826620f3729c37c5b39857021043c29790346b09b443fba5cb'
AND (
token = '6TxvlLXMFO0D/ehYf/P6VGThdw11hOFJWdoHtjswHPY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)