UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nza+pn3V/cM9dAQjnb4t0Guh0KSP+geCIHaRamk7Drk='
WHERE
key_id = 'c6b2156698b71dbe185181b3159ba3c0e24d4d2af8b0cfb8b934a29a4d5a3acf'
AND (
token = 'nza+pn3V/cM9dAQjnb4t0Guh0KSP+geCIHaRamk7Drk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)