UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lyhwTNcAHpX2LMFHj3bLgXsT9ZBW7VAHMNGfmaoR2R8='
WHERE
key_id = 'fad39d3d8130c58ab0141db0c927a1b908d76ab4307b8592c780291a692e5220'
AND (
token = 'lyhwTNcAHpX2LMFHj3bLgXsT9ZBW7VAHMNGfmaoR2R8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)