UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cHzPw5hsLliLjvv+z30ar+Whob3BeN4SC06RTyA13KQ='
WHERE
key_id = '7af48cf3f3c66d26bf80f11a2760a516aa3efcb7e5ceb7147cc8e7b4ddc6df61'
AND (
token = 'cHzPw5hsLliLjvv+z30ar+Whob3BeN4SC06RTyA13KQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)