UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xw1yLHu3lPNWTzBJO0fSqfDUgBGmQapJgaMvk5nrPFo='
WHERE
key_id = 'cdc7a7dcadda0b4f9c322fcbfd6a4b8d9a2ebdf668af06fab1b3935a08447c4c'
AND (
token = 'Xw1yLHu3lPNWTzBJO0fSqfDUgBGmQapJgaMvk5nrPFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)