UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vt56MjFiVEZUnDoAZ4JV45kyo3t0KxDY/Cp1Vgh2O+w='
WHERE
key_id = '9b8c633ae3270d48f0a8eed791bf2e0ffc0c2d9ba11a5da48ffff6163d17d104'
AND (
token = 'vt56MjFiVEZUnDoAZ4JV45kyo3t0KxDY/Cp1Vgh2O+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)