UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/IJhvSb2mTi63IkqLmE0iYTzGD4/n4of9IqZ/1vRpIo='
WHERE
key_id = 'ad8765cff43e0e0a667525a6c84e340a0b24423f0ce2d08b9fee708fb213a8c4'
AND (
token = '/IJhvSb2mTi63IkqLmE0iYTzGD4/n4of9IqZ/1vRpIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)