UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lB6MmA8puZXmmHs/JXRBTjd4s/MdX4OPr0MCss3JOFg='
WHERE
key_id = '9422afe11bbd6795cfaf8697e776d0c49b0eadfe85ef9f0a4cd638b9f431ce88'
AND (
token = 'lB6MmA8puZXmmHs/JXRBTjd4s/MdX4OPr0MCss3JOFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)