UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9BHDuy8629kNo+btMd999isQmbvEXCc+FNCSc35NHuI='
WHERE
key_id = 'c5ebc543da86d6c533956e75a99ffafcf72b7ff8eaa21a41cfb146e2764cde19'
AND (
token = '9BHDuy8629kNo+btMd999isQmbvEXCc+FNCSc35NHuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)