UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OGthSONZu78X+Qdxj+iShqszngZNpR1fNBH8pC4PxXE='
WHERE
key_id = '8a2cf50de02a076d3309d807cf9399ea2cf119040acc84da8e3575b46a03310f'
AND (
token = 'OGthSONZu78X+Qdxj+iShqszngZNpR1fNBH8pC4PxXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)