UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fN7QgChvuTUPEqfbkCRG5+4XjxCSrIjcyiqd/4edOgA='
WHERE
key_id = 'b9726ff1b3d3dff20177a43a6ae2158aeaef1a7cc7e87fc4f6910124588dfb4b'
AND (
token = 'fN7QgChvuTUPEqfbkCRG5+4XjxCSrIjcyiqd/4edOgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)