UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z9n1H0XColtESYlG2zALAFHXsH49qNDqaSTgw0ts3nQ='
WHERE
key_id = '5f8b7f9223c6b16ad1afa0e098a46a1494f66a1eb0403d311ed7d269dcec894e'
AND (
token = 'z9n1H0XColtESYlG2zALAFHXsH49qNDqaSTgw0ts3nQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)