UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j/9NRoLrYCc9u9l5F+XA6d0aonK8nyaMI21zN7bKS04='
WHERE
key_id = '4dd773b7f1e1940605a4a4bdec46069426a0b0fd008767c1345a9651fa2c2ff2'
AND (
token = 'j/9NRoLrYCc9u9l5F+XA6d0aonK8nyaMI21zN7bKS04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)