UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aOF1/rR/4XzH1d5MsrKTzNu4XlihJM4vtwBR2d/LHQM='
WHERE
key_id = '3df27962a9be309831365911b14f20b62cbabe3930fc90abdf5b85f40354188f'
AND (
token = 'aOF1/rR/4XzH1d5MsrKTzNu4XlihJM4vtwBR2d/LHQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)