UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nIT8tAt8y4yaqfC9xZdNyl5YVd/L5j37dOB5+/tDTTc='
WHERE
key_id = 'e5123b36f89d8f39b34dee06f9b2e3dcec43c349e2bf80ee2b0c62dff27e5aba'
AND (
token = 'nIT8tAt8y4yaqfC9xZdNyl5YVd/L5j37dOB5+/tDTTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)