UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iFYZiI7NP9DMv/yUNEdXD7BZWHL3Vus9DtxbhNhFomA='
WHERE
key_id = 'cc6e942ac69a3ffddab6bc3026699e47224445914662a4401da6c06d01a43fda'
AND (
token = 'iFYZiI7NP9DMv/yUNEdXD7BZWHL3Vus9DtxbhNhFomA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)