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