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