UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xmIdvYiqP2uP+RgWFi38fO101ymhxza6Y44bIYHa/jc='
WHERE
key_id = 'aa912c266d2e5b6715812f72af24ce8d1c4a14e49b742d72b7246b4610ce9097'
AND (
token = 'xmIdvYiqP2uP+RgWFi38fO101ymhxza6Y44bIYHa/jc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)