UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J/Pjtbn3scRcIKRRSAxzRFCrJVn3iGFsOvhR8ApPvJo='
WHERE
key_id = 'a9163f3b87dfe469e36e9ebca03c46c03f5206316528b5fbb1f06ef72c6395a7'
AND (
token = 'J/Pjtbn3scRcIKRRSAxzRFCrJVn3iGFsOvhR8ApPvJo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)