UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NJTZ5tn1DCGKUWvsz2qhuhV7j/mwvaizSEFW7UdstCM='
WHERE
key_id = '0d3bf5a4ac82cdfced178dd9889a5f74277aebbcef4b529936b1874ecd725634'
AND (
token = 'NJTZ5tn1DCGKUWvsz2qhuhV7j/mwvaizSEFW7UdstCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)