UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6IcIfyC7X8ddpB4BKJK7/4zyHJHiLJKWXgnPAS0OafA='
WHERE
key_id = 'd47525cca6bd1f2380ab04ef1d23f2e0a3493f2a060b2a3671d45531a884d58e'
AND (
token = '6IcIfyC7X8ddpB4BKJK7/4zyHJHiLJKWXgnPAS0OafA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)