UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lwRo4PkcFca6nOcoh0/6Zgh8yTIy9oSBf3QA4xBXcqI='
WHERE
key_id = '0237a413a5ec1a2ff9b910b0f8a6fe4d232fff78f0cd209d66b4f4b4a7ae63fa'
AND (
token = 'lwRo4PkcFca6nOcoh0/6Zgh8yTIy9oSBf3QA4xBXcqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)