UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1A6WU+VY47awhV5wW2JsDsakkLUHiO+DQDL2O4BXDGo='
WHERE
key_id = '767e6ceab78eb9189392d77029401bf8a5ca5db16e06e73cc6cbeb69ba24ae4a'
AND (
token = '1A6WU+VY47awhV5wW2JsDsakkLUHiO+DQDL2O4BXDGo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)