UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M4HX6EKOMUKCZxhSShE+D7TV0jxHXpGBa1r9wGka2No='
WHERE
key_id = 'a9490e9c125cae0f3ac23d67977c4afb4e9671e216ae26bcdc340aa0e57921ed'
AND (
token = 'M4HX6EKOMUKCZxhSShE+D7TV0jxHXpGBa1r9wGka2No='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)