UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zO5XE8iFmfMjPzY1cLQHPji/qikgiEZj1x8Qg9AlRqA='
WHERE
key_id = 'beb554da7ebd0a211cfb40d8b0777d6b81a96e8345ea63d8fd0972526f4d0583'
AND (
token = 'zO5XE8iFmfMjPzY1cLQHPji/qikgiEZj1x8Qg9AlRqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)