UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KPPlAoZ15vy2vUbn3+wG/f+YYevQxuB+czbxuRXbw6I='
WHERE
key_id = 'e747067d9c68775776e7215fd173da58a298fac17b849c20d2682b87194f5fe5'
AND (
token = 'KPPlAoZ15vy2vUbn3+wG/f+YYevQxuB+czbxuRXbw6I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)