UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SpDb8ewHi4LBejqIpF+y4adsshUBDs5cZYieCVzssLM='
WHERE
key_id = '67a42ea8fa7bcb2f62e763f2d4d40e1ea99ddd8cdbab7d2dd4d6acff43afd03a'
AND (
token = 'SpDb8ewHi4LBejqIpF+y4adsshUBDs5cZYieCVzssLM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)