UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B25GXk0N8WJcGq+FKdYCcFm1vBQi3Gfnj3IqjBLRDlU='
WHERE
key_id = 'd5c2f78f8e276bc167347428cba86e2a3dcf9a1d3db83ac053289f9de34d9367'
AND (
token = 'B25GXk0N8WJcGq+FKdYCcFm1vBQi3Gfnj3IqjBLRDlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)