UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tnFgjo74JwvYSioPpB1fW9DuMhV8ag39puAWqKWqgrw='
WHERE
key_id = '546a67a8391e60c40818fabf9e6b69af379cf4f3499525e10fe4ba3d8fe89f42'
AND (
token = 'tnFgjo74JwvYSioPpB1fW9DuMhV8ag39puAWqKWqgrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)