UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iVoPT8w3gd6pKOk+8EAwiZ9cqj1eBEwBzpy8/Pyytmk='
WHERE
key_id = '47cb80e3d5db744d6e21a0ff35f59bb16911acea600bccdaefbe87df7bfdb85a'
AND (
token = 'iVoPT8w3gd6pKOk+8EAwiZ9cqj1eBEwBzpy8/Pyytmk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)