UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xMgQpDSp1LV2pzc5cvrdAI4KKTTBWMLWZZDnpcZa8Rg='
WHERE
key_id = '49764f203d0aab37b1b465bc018686d65e754704df9c2b315cbcc071264d5999'
AND (
token = 'xMgQpDSp1LV2pzc5cvrdAI4KKTTBWMLWZZDnpcZa8Rg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)