UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7gXZ1Rv87tGYGoDcRwQQGzy+ajUv/8j+1aB2vjyiqkY='
WHERE
key_id = 'cdaccd52bc796def85842a2eb5d6a5500fd21c41c22327dbca34d70df9d82059'
AND (
token = '7gXZ1Rv87tGYGoDcRwQQGzy+ajUv/8j+1aB2vjyiqkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)